Tabela Death

Definicja tabeli Death

Name

Death

Code

Death

Comment

Informacja o zgonie pacjenta


Lista kolumn tabeli Death

Name

Code

PersonID

PersonID

EpisodeID

EpisodeID

EventID

EventID

PlaceKind

PlaceKind

UnusualDeath

UnusualDeath

Active

Active

Comments

Comments

BrainDeath

BrainDeath

BrainDeathDecisionDT

BrainDeathDecisionDT

OrganDonation

OrganDonation

BodyFoundDT

BodyFoundDT

Place

Place

OtherCause

OtherCause

InfectiousDisease

InfectiousDisease

DeclaringPersonInfo

DeclaringPersonInfo

PerformedPostMortemExam

PerformedPostMortemExam

IncludedAutopsyResult

IncludedAutopsyResult

MaritalstatusID

MaritalstatusID

DirectICDAndDeathInterv

DirectICDAndDeathInterv

DirectICDAndDeathIntervUnit

DirectICDAndDeathIntervUnit

IndirectICDAndDeathInterv

IndirectICDAndDeathInterv

IndirectICDAndDeathIntervUnit

IndirectICDAndDeathIntervUnit

OutICDAndDeathInterv

OutICDAndDeathInterv

OutICDAndDeathIntervUnit

OutICDAndDeathIntervUnit

DeclaringPersonID

DeclaringPersonID

NoAutopsyReason

NoAutopsyReason

DeathKindID

DeathKindID


Kolumna PersonID tabeli Death

Definicja kolumny PersonID tabeli Death

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pacjenta


Kolumna EpisodeID tabeli Death

Definicja kolumny EpisodeID tabeli Death

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID epizodu


Kolumna EventID tabeli Death

Definicja kolumny EventID tabeli Death

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zdarzenia


Kolumna PlaceKind tabeli Death

Definicja kolumny PlaceKind tabeli Death

Name

PlaceKind

Code

PlaceKind

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnusualDeath tabeli Death

Definicja kolumny UnusualDeath tabeli Death

Name

UnusualDeath

Code

UnusualDeath

Data Type

NUMBER(5)

Mandatory

No

Comment

Oznaczenie nietypowych zgonów


Kolumna Active tabeli Death

Definicja kolumny Active tabeli Death

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

No

Comment

 


Kolumna Comments tabeli Death

Definicja kolumny Comments tabeli Death

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz, np. do nietypowego zgonu


Kolumna BrainDeath tabeli Death

Definicja kolumny BrainDeath tabeli Death

Name

BrainDeath

Code

BrainDeath

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga: stwierdzenie trwalego i nieodwracalnego ustania czynnosci mózgu


Kolumna BrainDeathDecisionDT tabeli Death

Definicja kolumny BrainDeathDecisionDT tabeli Death

Name

BrainDeathDecisionDT

Code

BrainDeathDecisionDT

Data Type

DATE

Mandatory

No

Comment

Data i godzina wydania orzeczenia


Kolumna OrganDonation tabeli Death

Definicja kolumny OrganDonation tabeli Death

Name

OrganDonation

Code

OrganDonation

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga: Donacja narzadów


Kolumna BodyFoundDT tabeli Death

Definicja kolumny BodyFoundDT tabeli Death

Name

BodyFoundDT

Code

BodyFoundDT

Data Type

DATE

Mandatory

No

Comment

Data znalezienia zwlok


Kolumna Place tabeli Death

Definicja kolumny Place tabeli Death

Name

Place

Code

Place

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Miejsce znalezienia zwlok


Kolumna OtherCause tabeli Death

Definicja kolumny OtherCause tabeli Death

Name

OtherCause

Code

OtherCause

Data Type

VARCHAR2(512)

Mandatory

No

Comment

Inne istotne okolicznosci smierci


Kolumna InfectiousDisease tabeli Death

Definicja kolumny InfectiousDisease tabeli Death

Name

InfectiousDisease

Code

InfectiousDisease

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy zgon nastapil w wyniku choroby zakaznej


Kolumna DeclaringPersonInfo tabeli Death

Definicja kolumny DeclaringPersonInfo tabeli Death

Name

DeclaringPersonInfo

Code

DeclaringPersonInfo

Data Type

VARCHAR2(200)

Mandatory

No

Comment

Informacje o osobie stwierdzajacej zgon


Kolumna PerformedPostMortemExam tabeli Death

Definicja kolumny PerformedPostMortemExam tabeli Death

Name

PerformedPostMortemExam

Code

PerformedPostMortemExam

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy zostalo wykonane badanie posmiertne


Kolumna IncludedAutopsyResult tabeli Death

Definicja kolumny IncludedAutopsyResult tabeli Death

Name

IncludedAutopsyResult

Code

IncludedAutopsyResult

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy zostala wykonana sekcja zwlok


Kolumna MaritalstatusID tabeli Death

Definicja kolumny MaritalstatusID tabeli Death

Name

MaritalstatusID

Code

MaritalstatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

Stan cywilny osoby zmarlej


Kolumna DirectICDAndDeathInterv tabeli Death

Definicja kolumny DirectICDAndDeathInterv tabeli Death

Name

DirectICDAndDeathInterv

Code

DirectICDAndDeathInterv

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Odstep czasu pomiedzy przyczyna bezposrednia a smiercia


Kolumna DirectICDAndDeathIntervUnit tabeli Death

Definicja kolumny DirectICDAndDeathIntervUnit tabeli Death

Name

DirectICDAndDeathIntervUnit

Code

DirectICDAndDeathIntervUnit

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Jednostka czasu


Kolumna IndirectICDAndDeathInterv tabeli Death

Definicja kolumny IndirectICDAndDeathInterv tabeli Death

Name

IndirectICDAndDeathInterv

Code

IndirectICDAndDeathInterv

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Odstep czasu pomiedzy przyczyna posrednia a smiercia


Kolumna IndirectICDAndDeathIntervUnit tabeli Death

Definicja kolumny IndirectICDAndDeathIntervUnit tabeli Death

Name

IndirectICDAndDeathIntervUnit

Code

IndirectICDAndDeathIntervUnit

Data Type

VARCHAR2(1)

Mandatory

No

Comment

Jednostka czasu


Kolumna OutICDAndDeathInterv tabeli Death

Definicja kolumny OutICDAndDeathInterv tabeli Death

Name

OutICDAndDeathInterv

Code

OutICDAndDeathInterv

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Odstep czasu pomiedzy przyczyna wyjsciowa a smiercia


Kolumna OutICDAndDeathIntervUnit tabeli Death

Definicja kolumny OutICDAndDeathIntervUnit tabeli Death

Name

OutICDAndDeathIntervUnit

Code

OutICDAndDeathIntervUnit

Data Type

VARCHAR2(1)

Mandatory

No

Comment

jednostka czasu


Kolumna DeclaringPersonID tabeli Death

Definicja kolumny DeclaringPersonID tabeli Death

Name

DeclaringPersonID

Code

DeclaringPersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

id lekarza stwierdzajacego zgon


Kolumna NoAutopsyReason tabeli Death

Definicja kolumny NoAutopsyReason tabeli Death

Name

NoAutopsyReason

Code

NoAutopsyReason

Data Type

VARCHAR2(512)

Mandatory

No

Comment

kolumna bedzie przechowywala uzasadnienia zaniechania wykonania sekcji zwlok


Kolumna DeathKindID tabeli Death

Definicja kolumny DeathKindID tabeli Death

Name

DeathKindID

Code

DeathKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

Rodzaj zgonu pacjenta


Lista kluczy tabeli Death

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Death

Definicja klucza Identifier_1 tabeli Death

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment